﻿using System;
using System.Data.Linq.Mapping;

namespace StudentMgmt.Model
{
    [Serializable]
    [Table(Name = "Punishment")]
    public class PunishmentInfo
    {
        public PunishmentInfo() { }
        public PunishmentInfo(int id,string StuNo,
            string PunishmentCode, DateTime CreateDate, 
            char PunishmentEnable, string PunishmentDescription)
        {
            Punishment_Id = id;
            this.StuNo = StuNo;
            this.Punishment_Code = PunishmentCode;
            this.Create_Date = CreateDate;
            this.Punishment_Enable = PunishmentEnable;
            this.Punishment_Descriptions = PunishmentDescription;
        }
        [Column(Name = "Punishment_Id", IsPrimaryKey = true, DbType = "int")]
        public int Punishment_Id { get; set; }
        [Column(Name ="StuNo",DbType ="char(6)")]
        public string StuNo { set; get; }
        [Column(Name = "Punishment_Code", DbType ="char(5)")]
        public string Punishment_Code { set; get; }
        [Column(Name = "Create_Date", DbType = "date")]
        public DateTime Create_Date { set; get; }
        [Column(Name = "Punishment_Enable", DbType = "char(1)")]
        public char Punishment_Enable { set; get; }
        [Column(Name = "Punishment_Descriptions", DbType = "varchar(4000)")]
        public string Punishment_Descriptions { set; get; }
    }
}
